VoiceGuide IVR Software Main Page
Jump to content

Microsoft Access Error Messages

Recommended Posts

I'm using a simple database query of the form "SELECT fieldname FROM tablename WHERE keyfield='somevalue'", referencing an Access database. So, in the database module I'm just specifying an mdb file, no connect string.

 

I'm using various queries in my script, most of which work fine. One particular query, no more complicated than any of the others is resulting in a FAIL path being taken ... but I have no idea why!!

 

Is there some way to obtain the error message that is associated with the query? I'm thinking that something really simply is going wrong, but have not been able to figure it out :( At the very least, is there some way of knowing the exact query string that is being sent to Access?

 

Thanks,

Share this post


Link to post

Could you please post a copy of VoiceGuide's Trace Logs which captures the problem, this will allow us to see what happened.

 

Enable logging by setting the log levels to 10 in VG.INI as per below:

[Log]

 

VoiceGuide=10

Then restart VG and make a test call which demonstrates the problem.

 

Trace files will be created in VG's \log\ subdirectory.

 

Please post the traces and the VoiceGuide script used.

 

When posting traces/scripts please .ZIP them up and post them as attachments.

Share this post


Link to post

Thank you, Gentlemen.

 

Turning on the log info to 10 gave me all the information I needed to find the problem, and actually revealed other latent issues yet to be found the hard way :)

 

Now if only I can get the TTS stuff working :) :)

 

Quilpole.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×